package com.edu.admin.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import com.edu.admin.common.BaseMapper;
import com.edu.admin.entity.SysSchoolPhase;
import com.edu.admin.vo.SchoolPhaseVo;

/**
 * 学校学段关联表数据操作接口
 * 
 * @author Wangjiong
 * 
 */
@Mapper
public interface SchoolPhaseMapper extends BaseMapper<SysSchoolPhase> {

	/**
	 * 学校学段关联列表
	 * 
	 * @param schoolId
	 * 
	 * @return List<SchoolPhaseVo>
	 */
	List<SchoolPhaseVo> getSchoolPhaseListBySchoolId(Long schoolId);
	
	/**
	 * 学校学段查询
	 * 
	 * @param schoolId
	 * 
	 * @return List<SchoolPhaseVo>
	 */
	List<SchoolPhaseVo> getSchoolPhaseBySchoolIdAndPhaseName(@Param("schoolId")Long schoolId,
															@Param("phaseName") String phaseName);
	
	/**
	 * 删除学校学段关联
	 * 
	 * @param schoolId
	 * 
	 * @return
	 */
	void deleteSchoolPhaseBySchoolId(Long schoolId);
	

}
